﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="PCV_CLINICDataSet" targetNamespace="http://tempuri.org/PCV_CLINICDataSet.xsd" xmlns:mstns="http://tempuri.org/PCV_CLINICDataSet.xsd" xmlns="http://tempuri.org/PCV_CLINICDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="PCV_CLINICConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="PCV_CLINICConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.IControl.My.MySettings.GlobalReference.Default.PCV_CLINICConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DoSinhHieuTableAdapter" GeneratorDataComponentClassName="DoSinhHieuTableAdapter" Name="DoSinhHieu" UserDataComponentName="DoSinhHieuTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_Clinic.dbo.DoSinhHieu" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DoSinhHieu] WHERE (([ma] = @Original_ma) AND ((@IsNull_masophieu = 1 AND [masophieu] IS NULL) OR ([masophieu] = @Original_masophieu)) AND ((@IsNull_mabenhnhan = 1 AND [mabenhnhan] IS NULL) OR ([mabenhnhan] = @Original_mabenhnhan)) AND ((@IsNull_ten = 1 AND [ten] IS NULL) OR ([ten] = @Original_ten)) AND ((@IsNull_gioitinh = 1 AND [gioitinh] IS NULL) OR ([gioitinh] = @Original_gioitinh)) AND ((@IsNull_ngaysinh = 1 AND [ngaysinh] IS NULL) OR ([ngaysinh] = @Original_ngaysinh)) AND ((@IsNull_tuoi = 1 AND [tuoi] IS NULL) OR ([tuoi] = @Original_tuoi)) AND ((@IsNull_diachi = 1 AND [diachi] IS NULL) OR ([diachi] = @Original_diachi)) AND ((@IsNull_ngaydo = 1 AND [ngaydo] IS NULL) OR ([ngaydo] = @Original_ngaydo)) AND ((@IsNull_mach = 1 AND [mach] IS NULL) OR ([mach] = @Original_mach)) AND ((@IsNull_nhietdo = 1 AND [nhietdo] IS NULL) OR ([nhietdo] = @Original_nhietdo)) AND ((@IsNull_huyetap = 1 AND [huyetap] IS NULL) OR ([huyetap] = @Original_huyetap)) AND ((@IsNull_nhiptho = 1 AND [nhiptho] IS NULL) OR ([nhiptho] = @Original_nhiptho)) AND ((@IsNull_cannang = 1 AND [cannang] IS NULL) OR ([cannang] = @Original_cannang)) AND ((@IsNull_chieucao = 1 AND [chieucao] IS NULL) OR ([chieucao] = @Original_chieucao)) AND ((@IsNull_vongbung = 1 AND [vongbung] IS NULL) OR ([vongbung] = @Original_vongbung)) AND ((@IsNull_bmi = 1 AND [bmi] IS NULL) OR ([bmi] = @Original_bmi)) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ((@IsNull_tinhtrang = 1 AND [tinhtrang] IS NULL) OR ([tinhtrang] = @Original_tinhtrang)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_masophieu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="masophieu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_masophieu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masophieu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mabenhnhan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mabenhnhan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mabenhnhan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mabenhnhan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_gioitinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="gioitinh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_gioitinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="gioitinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaysinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaysinh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaysinh" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaysinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tuoi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tuoi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_tuoi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tuoi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diachi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaydo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaydo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaydo" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaydo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mach" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mach" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_mach" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mach" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nhietdo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nhietdo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nhietdo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nhietdo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_huyetap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="huyetap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_huyetap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="huyetap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nhiptho" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nhiptho" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nhiptho" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nhiptho" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cannang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cannang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_cannang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cannang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chieucao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chieucao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_chieucao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chieucao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_vongbung" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="vongbung" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_vongbung" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="vongbung" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bmi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bmi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_bmi" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="bmi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tinhtrang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DoSinhHieu] ([ma], [masophieu], [mabenhnhan], [ten], [gioitinh], [ngaysinh], [tuoi], [diachi], [ngaydo], [mach], [nhietdo], [huyetap], [nhiptho], [cannang], [chieucao], [vongbung], [bmi], [ghichu], [tinhtrang], [chinhanh]) VALUES (@ma, @masophieu, @mabenhnhan, @ten, @gioitinh, @ngaysinh, @tuoi, @diachi, @ngaydo, @mach, @nhietdo, @huyetap, @nhiptho, @cannang, @chieucao, @vongbung, @bmi, @ghichu, @tinhtrang, @chinhanh);
SELECT ma, masophieu, mabenhnhan, ten, gioitinh, ngaysinh, tuoi, diachi, ngaydo, mach, nhietdo, huyetap, nhiptho, cannang, chieucao, vongbung, bmi, ghichu, tinhtrang, chinhanh, id FROM DoSinhHieu WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@masophieu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masophieu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mabenhnhan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mabenhnhan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@gioitinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="gioitinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaysinh" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaysinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@tuoi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tuoi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaydo" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaydo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@mach" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mach" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nhietdo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nhietdo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@huyetap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="huyetap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nhiptho" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nhiptho" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@cannang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cannang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@chieucao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chieucao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@vongbung" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="vongbung" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@bmi" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="bmi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ma, masophieu, mabenhnhan, ten, gioitinh, ngaysinh, tuoi, diachi, ngaydo, mach, nhietdo, huyetap, nhiptho, cannang, chieucao, vongbung, bmi, ghichu, tinhtrang, chinhanh, id FROM dbo.DoSinhHieu</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DoSinhHieu] SET [ma] = @ma, [masophieu] = @masophieu, [mabenhnhan] = @mabenhnhan, [ten] = @ten, [gioitinh] = @gioitinh, [ngaysinh] = @ngaysinh, [tuoi] = @tuoi, [diachi] = @diachi, [ngaydo] = @ngaydo, [mach] = @mach, [nhietdo] = @nhietdo, [huyetap] = @huyetap, [nhiptho] = @nhiptho, [cannang] = @cannang, [chieucao] = @chieucao, [vongbung] = @vongbung, [bmi] = @bmi, [ghichu] = @ghichu, [tinhtrang] = @tinhtrang, [chinhanh] = @chinhanh WHERE (([ma] = @Original_ma) AND ((@IsNull_masophieu = 1 AND [masophieu] IS NULL) OR ([masophieu] = @Original_masophieu)) AND ((@IsNull_mabenhnhan = 1 AND [mabenhnhan] IS NULL) OR ([mabenhnhan] = @Original_mabenhnhan)) AND ((@IsNull_ten = 1 AND [ten] IS NULL) OR ([ten] = @Original_ten)) AND ((@IsNull_gioitinh = 1 AND [gioitinh] IS NULL) OR ([gioitinh] = @Original_gioitinh)) AND ((@IsNull_ngaysinh = 1 AND [ngaysinh] IS NULL) OR ([ngaysinh] = @Original_ngaysinh)) AND ((@IsNull_tuoi = 1 AND [tuoi] IS NULL) OR ([tuoi] = @Original_tuoi)) AND ((@IsNull_diachi = 1 AND [diachi] IS NULL) OR ([diachi] = @Original_diachi)) AND ((@IsNull_ngaydo = 1 AND [ngaydo] IS NULL) OR ([ngaydo] = @Original_ngaydo)) AND ((@IsNull_mach = 1 AND [mach] IS NULL) OR ([mach] = @Original_mach)) AND ((@IsNull_nhietdo = 1 AND [nhietdo] IS NULL) OR ([nhietdo] = @Original_nhietdo)) AND ((@IsNull_huyetap = 1 AND [huyetap] IS NULL) OR ([huyetap] = @Original_huyetap)) AND ((@IsNull_nhiptho = 1 AND [nhiptho] IS NULL) OR ([nhiptho] = @Original_nhiptho)) AND ((@IsNull_cannang = 1 AND [cannang] IS NULL) OR ([cannang] = @Original_cannang)) AND ((@IsNull_chieucao = 1 AND [chieucao] IS NULL) OR ([chieucao] = @Original_chieucao)) AND ((@IsNull_vongbung = 1 AND [vongbung] IS NULL) OR ([vongbung] = @Original_vongbung)) AND ((@IsNull_bmi = 1 AND [bmi] IS NULL) OR ([bmi] = @Original_bmi)) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ((@IsNull_tinhtrang = 1 AND [tinhtrang] IS NULL) OR ([tinhtrang] = @Original_tinhtrang)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ([id] = @Original_id));
SELECT ma, masophieu, mabenhnhan, ten, gioitinh, ngaysinh, tuoi, diachi, ngaydo, mach, nhietdo, huyetap, nhiptho, cannang, chieucao, vongbung, bmi, ghichu, tinhtrang, chinhanh, id FROM DoSinhHieu WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@masophieu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masophieu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mabenhnhan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mabenhnhan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@gioitinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="gioitinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaysinh" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaysinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@tuoi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tuoi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaydo" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaydo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@mach" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mach" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nhietdo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nhietdo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@huyetap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="huyetap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nhiptho" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nhiptho" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@cannang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cannang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@chieucao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chieucao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@vongbung" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="vongbung" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@bmi" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="bmi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_masophieu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="masophieu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_masophieu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masophieu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mabenhnhan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mabenhnhan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mabenhnhan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mabenhnhan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_gioitinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="gioitinh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_gioitinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="gioitinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaysinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaysinh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaysinh" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaysinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tuoi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tuoi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_tuoi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tuoi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diachi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaydo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaydo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaydo" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaydo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mach" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mach" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_mach" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mach" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nhietdo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nhietdo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nhietdo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nhietdo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_huyetap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="huyetap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_huyetap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="huyetap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nhiptho" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nhiptho" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nhiptho" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nhiptho" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cannang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cannang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_cannang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cannang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chieucao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chieucao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_chieucao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chieucao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_vongbung" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="vongbung" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_vongbung" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="vongbung" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bmi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bmi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_bmi" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="bmi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tinhtrang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="PCV_CLINIC.dbo.DoSinhHieu" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="masophieu" DataSetColumn="masophieu" />
              <Mapping SourceColumn="mabenhnhan" DataSetColumn="mabenhnhan" />
              <Mapping SourceColumn="ten" DataSetColumn="ten" />
              <Mapping SourceColumn="gioitinh" DataSetColumn="gioitinh" />
              <Mapping SourceColumn="ngaysinh" DataSetColumn="ngaysinh" />
              <Mapping SourceColumn="tuoi" DataSetColumn="tuoi" />
              <Mapping SourceColumn="diachi" DataSetColumn="diachi" />
              <Mapping SourceColumn="ngaydo" DataSetColumn="ngaydo" />
              <Mapping SourceColumn="mach" DataSetColumn="mach" />
              <Mapping SourceColumn="nhietdo" DataSetColumn="nhietdo" />
              <Mapping SourceColumn="huyetap" DataSetColumn="huyetap" />
              <Mapping SourceColumn="nhiptho" DataSetColumn="nhiptho" />
              <Mapping SourceColumn="cannang" DataSetColumn="cannang" />
              <Mapping SourceColumn="chieucao" DataSetColumn="chieucao" />
              <Mapping SourceColumn="vongbung" DataSetColumn="vongbung" />
              <Mapping SourceColumn="bmi" DataSetColumn="bmi" />
              <Mapping SourceColumn="ghichu" DataSetColumn="ghichu" />
              <Mapping SourceColumn="tinhtrang" DataSetColumn="tinhtrang" />
              <Mapping SourceColumn="chinhanh" DataSetColumn="chinhanh" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DoSinhHieuTienSuBenhTableAdapter" GeneratorDataComponentClassName="DoSinhHieuTienSuBenhTableAdapter" Name="DoSinhHieuTienSuBenh" UserDataComponentName="DoSinhHieuTienSuBenhTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_Clinic.dbo.DoSinhHieuTienSuBenh" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DoSinhHieuTienSuBenh] WHERE (([ma] = @Original_ma) AND ((@IsNull_masophieu = 1 AND [masophieu] IS NULL) OR ([masophieu] = @Original_masophieu)) AND ((@IsNull_mabenh = 1 AND [mabenh] IS NULL) OR ([mabenh] = @Original_mabenh)) AND ((@IsNull_tenbenh = 1 AND [tenbenh] IS NULL) OR ([tenbenh] = @Original_tenbenh)) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ([uid] = @Original_uid) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_masophieu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="masophieu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_masophieu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masophieu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mabenh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mabenh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mabenh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mabenh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tenbenh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tenbenh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tenbenh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenbenh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_uid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="uid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DoSinhHieuTienSuBenh] ([ma], [masophieu], [mabenh], [tenbenh], [ghichu], [uid]) VALUES (@ma, @masophieu, @mabenh, @tenbenh, @ghichu, @uid);
SELECT ma, masophieu, mabenh, tenbenh, ghichu, uid, id FROM DoSinhHieuTienSuBenh WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@masophieu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masophieu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mabenh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mabenh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tenbenh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenbenh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@uid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="uid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ma, masophieu, mabenh, tenbenh, ghichu, uid, id FROM dbo.DoSinhHieuTienSuBenh</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DoSinhHieuTienSuBenh] SET [ma] = @ma, [masophieu] = @masophieu, [mabenh] = @mabenh, [tenbenh] = @tenbenh, [ghichu] = @ghichu, [uid] = @uid WHERE (([ma] = @Original_ma) AND ((@IsNull_masophieu = 1 AND [masophieu] IS NULL) OR ([masophieu] = @Original_masophieu)) AND ((@IsNull_mabenh = 1 AND [mabenh] IS NULL) OR ([mabenh] = @Original_mabenh)) AND ((@IsNull_tenbenh = 1 AND [tenbenh] IS NULL) OR ([tenbenh] = @Original_tenbenh)) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ([uid] = @Original_uid) AND ([id] = @Original_id));
SELECT ma, masophieu, mabenh, tenbenh, ghichu, uid, id FROM DoSinhHieuTienSuBenh WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@masophieu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masophieu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mabenh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mabenh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tenbenh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenbenh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@uid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="uid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_masophieu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="masophieu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_masophieu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masophieu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mabenh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mabenh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mabenh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mabenh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tenbenh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tenbenh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tenbenh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenbenh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_uid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="uid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="PCV_CLINIC.dbo.DoSinhHieuTienSuBenh" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="masophieu" DataSetColumn="masophieu" />
              <Mapping SourceColumn="mabenh" DataSetColumn="mabenh" />
              <Mapping SourceColumn="tenbenh" DataSetColumn="tenbenh" />
              <Mapping SourceColumn="ghichu" DataSetColumn="ghichu" />
              <Mapping SourceColumn="uid" DataSetColumn="uid" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="getTCTonKho_TheKho_TheoLo_HanDungTableAdapter" GeneratorDataComponentClassName="getTCTonKho_TheKho_TheoLo_HanDungTableAdapter" Name="getTCTonKho_TheKho_TheoLo_HanDung" UserDataComponentName="getTCTonKho_TheKho_TheoLo_HanDungTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_Clinic.dbo.getTCTonKho_TheKho_TheoLo_HanDung" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.getTCTonKho_TheKho_TheoLo_HanDung</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@tungay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@denngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@mahang" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText />
                    <Parameters />
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="ngaychungtu" DataSetColumn="ngaychungtu" />
              <Mapping SourceColumn="sochungtu" DataSetColumn="sochungtu" />
              <Mapping SourceColumn="sohoadon" DataSetColumn="sohoadon" />
              <Mapping SourceColumn="ngayhoadon" DataSetColumn="ngayhoadon" />
              <Mapping SourceColumn="mahang" DataSetColumn="mahang" />
              <Mapping SourceColumn="tenhang" DataSetColumn="tenhang" />
              <Mapping SourceColumn="dvt" DataSetColumn="dvt" />
              <Mapping SourceColumn="quicach" DataSetColumn="quicach" />
              <Mapping SourceColumn="solo" DataSetColumn="solo" />
              <Mapping SourceColumn="hsd" DataSetColumn="hsd" />
              <Mapping SourceColumn="soluongdauky" DataSetColumn="soluongdauky" />
              <Mapping SourceColumn="soluongnhap" DataSetColumn="soluongnhap" />
              <Mapping SourceColumn="soluongxuat" DataSetColumn="soluongxuat" />
              <Mapping SourceColumn="soluongcuoiky" DataSetColumn="soluongcuoiky" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DMIcdTableAdapter" GeneratorDataComponentClassName="DMIcdTableAdapter" Name="DMIcd" UserDataComponentName="DMIcdTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_Clinic.dbo.DMIcd" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DMIcd] WHERE (((@IsNull_ma = 1 AND [ma] IS NULL) OR ([ma] = @Original_ma)) AND ((@IsNull_ten = 1 AND [ten] IS NULL) OR ([ten] = @Original_ten)) AND ((@IsNull_tentienganh = 1 AND [tentienganh] IS NULL) OR ([tentienganh] = @Original_tentienganh)) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ma" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tentienganh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tentienganh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tentienganh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tentienganh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DMIcd] ([ma], [ten], [tentienganh]) VALUES (@ma, @ten, @tentienganh);
SELECT ma, ten, tentienganh, id FROM DMIcd WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tentienganh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tentienganh" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ma, ten, tentienganh, id FROM dbo.DMIcd</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DMIcd] SET [ma] = @ma, [ten] = @ten, [tentienganh] = @tentienganh WHERE (((@IsNull_ma = 1 AND [ma] IS NULL) OR ([ma] = @Original_ma)) AND ((@IsNull_ten = 1 AND [ten] IS NULL) OR ([ten] = @Original_ten)) AND ((@IsNull_tentienganh = 1 AND [tentienganh] IS NULL) OR ([tentienganh] = @Original_tentienganh)) AND ([id] = @Original_id));
SELECT ma, ten, tentienganh, id FROM DMIcd WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tentienganh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tentienganh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ma" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tentienganh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tentienganh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tentienganh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tentienganh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="PCV_Clinic.dbo.DMIcd" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="ten" DataSetColumn="ten" />
              <Mapping SourceColumn="tentienganh" DataSetColumn="tentienganh" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DMKhoaTableAdapter" GeneratorDataComponentClassName="DMKhoaTableAdapter" Name="DMKhoa" UserDataComponentName="DMKhoaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_CLINICConnectionString (MySettings)" DbObjectName="PCV_Clinic.dbo.DMKhoa" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DMKhoa] WHERE (((@IsNull_ma = 1 AND [ma] IS NULL) OR ([ma] = @Original_ma)) AND ((@IsNull_ten = 1 AND [ten] IS NULL) OR ([ten] = @Original_ten)) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ((@IsNull_tinhtrang = 1 AND [tinhtrang] IS NULL) OR ([tinhtrang] = @Original_tinhtrang)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ma" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tinhtrang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DMKhoa] ([ma], [ten], [ghichu], [tinhtrang], [chinhanh]) VALUES (@ma, @ten, @ghichu, @tinhtrang, @chinhanh);
SELECT ma, ten, ghichu, tinhtrang, chinhanh, id FROM DMKhoa WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ma, ten, ghichu, tinhtrang, chinhanh, id FROM dbo.DMKhoa</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DMKhoa] SET [ma] = @ma, [ten] = @ten, [ghichu] = @ghichu, [tinhtrang] = @tinhtrang, [chinhanh] = @chinhanh WHERE (((@IsNull_ma = 1 AND [ma] IS NULL) OR ([ma] = @Original_ma)) AND ((@IsNull_ten = 1 AND [ten] IS NULL) OR ([ten] = @Original_ten)) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ((@IsNull_tinhtrang = 1 AND [tinhtrang] IS NULL) OR ([tinhtrang] = @Original_tinhtrang)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ([id] = @Original_id));
SELECT ma, ten, ghichu, tinhtrang, chinhanh, id FROM DMKhoa WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ma" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tinhtrang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="PCV_Clinic.dbo.DMKhoa" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="ten" DataSetColumn="ten" />
              <Mapping SourceColumn="ghichu" DataSetColumn="ghichu" />
              <Mapping SourceColumn="tinhtrang" DataSetColumn="tinhtrang" />
              <Mapping SourceColumn="chinhanh" DataSetColumn="chinhanh" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="PCV_CLINICDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="PCV_CLINICDataSet" msprop:Generator_UserDSName="PCV_CLINICDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="DoSinhHieu" msprop:Generator_TableClassName="DoSinhHieuDataTable" msprop:Generator_TableVarName="tableDoSinhHieu" msprop:Generator_RowChangedName="DoSinhHieuRowChanged" msprop:Generator_TablePropName="DoSinhHieu" msprop:Generator_RowDeletingName="DoSinhHieuRowDeleting" msprop:Generator_RowChangingName="DoSinhHieuRowChanging" msprop:Generator_RowEvHandlerName="DoSinhHieuRowChangeEventHandler" msprop:Generator_RowDeletedName="DoSinhHieuRowDeleted" msprop:Generator_RowClassName="DoSinhHieuRow" msprop:Generator_UserTableName="DoSinhHieu" msprop:Generator_RowEvArgName="DoSinhHieuRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="masophieu" msprop:Generator_ColumnVarNameInTable="columnmasophieu" msprop:Generator_ColumnPropNameInRow="masophieu" msprop:Generator_ColumnPropNameInTable="masophieuColumn" msprop:Generator_UserColumnName="masophieu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="mabenhnhan" msprop:Generator_ColumnVarNameInTable="columnmabenhnhan" msprop:Generator_ColumnPropNameInRow="mabenhnhan" msprop:Generator_ColumnPropNameInTable="mabenhnhanColumn" msprop:Generator_UserColumnName="mabenhnhan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ten" msprop:Generator_ColumnVarNameInTable="columnten" msprop:Generator_ColumnPropNameInRow="ten" msprop:Generator_ColumnPropNameInTable="tenColumn" msprop:Generator_UserColumnName="ten" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="gioitinh" msprop:Generator_ColumnVarNameInTable="columngioitinh" msprop:Generator_ColumnPropNameInRow="gioitinh" msprop:Generator_ColumnPropNameInTable="gioitinhColumn" msprop:Generator_UserColumnName="gioitinh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngaysinh" msprop:Generator_ColumnVarNameInTable="columnngaysinh" msprop:Generator_ColumnPropNameInRow="ngaysinh" msprop:Generator_ColumnPropNameInTable="ngaysinhColumn" msprop:Generator_UserColumnName="ngaysinh" type="xs:dateTime" minOccurs="0" />
              <xs:element name="tuoi" msprop:Generator_ColumnVarNameInTable="columntuoi" msprop:Generator_ColumnPropNameInRow="tuoi" msprop:Generator_ColumnPropNameInTable="tuoiColumn" msprop:Generator_UserColumnName="tuoi" type="xs:int" minOccurs="0" />
              <xs:element name="diachi" msprop:Generator_ColumnVarNameInTable="columndiachi" msprop:Generator_ColumnPropNameInRow="diachi" msprop:Generator_ColumnPropNameInTable="diachiColumn" msprop:Generator_UserColumnName="diachi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngaydo" msprop:Generator_ColumnVarNameInTable="columnngaydo" msprop:Generator_ColumnPropNameInRow="ngaydo" msprop:Generator_ColumnPropNameInTable="ngaydoColumn" msprop:Generator_UserColumnName="ngaydo" type="xs:dateTime" minOccurs="0" />
              <xs:element name="mach" msprop:Generator_ColumnVarNameInTable="columnmach" msprop:Generator_ColumnPropNameInRow="mach" msprop:Generator_ColumnPropNameInTable="machColumn" msprop:Generator_UserColumnName="mach" type="xs:int" minOccurs="0" />
              <xs:element name="nhietdo" msprop:Generator_ColumnVarNameInTable="columnnhietdo" msprop:Generator_ColumnPropNameInRow="nhietdo" msprop:Generator_ColumnPropNameInTable="nhietdoColumn" msprop:Generator_UserColumnName="nhietdo" type="xs:int" minOccurs="0" />
              <xs:element name="huyetap" msprop:Generator_ColumnVarNameInTable="columnhuyetap" msprop:Generator_ColumnPropNameInRow="huyetap" msprop:Generator_ColumnPropNameInTable="huyetapColumn" msprop:Generator_UserColumnName="huyetap" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nhiptho" msprop:Generator_ColumnVarNameInTable="columnnhiptho" msprop:Generator_ColumnPropNameInRow="nhiptho" msprop:Generator_ColumnPropNameInTable="nhipthoColumn" msprop:Generator_UserColumnName="nhiptho" type="xs:int" minOccurs="0" />
              <xs:element name="cannang" msprop:Generator_ColumnVarNameInTable="columncannang" msprop:Generator_ColumnPropNameInRow="cannang" msprop:Generator_ColumnPropNameInTable="cannangColumn" msprop:Generator_UserColumnName="cannang" type="xs:int" minOccurs="0" />
              <xs:element name="chieucao" msprop:Generator_ColumnVarNameInTable="columnchieucao" msprop:Generator_ColumnPropNameInRow="chieucao" msprop:Generator_ColumnPropNameInTable="chieucaoColumn" msprop:Generator_UserColumnName="chieucao" type="xs:int" minOccurs="0" />
              <xs:element name="vongbung" msprop:Generator_ColumnVarNameInTable="columnvongbung" msprop:Generator_ColumnPropNameInRow="vongbung" msprop:Generator_ColumnPropNameInTable="vongbungColumn" msprop:Generator_UserColumnName="vongbung" type="xs:int" minOccurs="0" />
              <xs:element name="bmi" msprop:Generator_ColumnVarNameInTable="columnbmi" msprop:Generator_ColumnPropNameInRow="bmi" msprop:Generator_ColumnPropNameInTable="bmiColumn" msprop:Generator_UserColumnName="bmi" type="xs:decimal" minOccurs="0" />
              <xs:element name="ghichu" msprop:Generator_ColumnVarNameInTable="columnghichu" msprop:Generator_ColumnPropNameInRow="ghichu" msprop:Generator_ColumnPropNameInTable="ghichuColumn" msprop:Generator_UserColumnName="ghichu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tinhtrang" msprop:Generator_ColumnVarNameInTable="columntinhtrang" msprop:Generator_ColumnPropNameInRow="tinhtrang" msprop:Generator_ColumnPropNameInTable="tinhtrangColumn" msprop:Generator_UserColumnName="tinhtrang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chinhanh" msprop:Generator_ColumnVarNameInTable="columnchinhanh" msprop:Generator_ColumnPropNameInRow="chinhanh" msprop:Generator_ColumnPropNameInTable="chinhanhColumn" msprop:Generator_UserColumnName="chinhanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DoSinhHieuTienSuBenh" msprop:Generator_TableClassName="DoSinhHieuTienSuBenhDataTable" msprop:Generator_TableVarName="tableDoSinhHieuTienSuBenh" msprop:Generator_RowChangedName="DoSinhHieuTienSuBenhRowChanged" msprop:Generator_TablePropName="DoSinhHieuTienSuBenh" msprop:Generator_RowDeletingName="DoSinhHieuTienSuBenhRowDeleting" msprop:Generator_RowChangingName="DoSinhHieuTienSuBenhRowChanging" msprop:Generator_RowEvHandlerName="DoSinhHieuTienSuBenhRowChangeEventHandler" msprop:Generator_RowDeletedName="DoSinhHieuTienSuBenhRowDeleted" msprop:Generator_RowClassName="DoSinhHieuTienSuBenhRow" msprop:Generator_UserTableName="DoSinhHieuTienSuBenh" msprop:Generator_RowEvArgName="DoSinhHieuTienSuBenhRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="masophieu" msprop:Generator_ColumnVarNameInTable="columnmasophieu" msprop:Generator_ColumnPropNameInRow="masophieu" msprop:Generator_ColumnPropNameInTable="masophieuColumn" msprop:Generator_UserColumnName="masophieu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="mabenh" msprop:Generator_ColumnVarNameInTable="columnmabenh" msprop:Generator_ColumnPropNameInRow="mabenh" msprop:Generator_ColumnPropNameInTable="mabenhColumn" msprop:Generator_UserColumnName="mabenh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tenbenh" msprop:Generator_ColumnVarNameInTable="columntenbenh" msprop:Generator_ColumnPropNameInRow="tenbenh" msprop:Generator_ColumnPropNameInTable="tenbenhColumn" msprop:Generator_UserColumnName="tenbenh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ghichu" msprop:Generator_ColumnVarNameInTable="columnghichu" msprop:Generator_ColumnPropNameInRow="ghichu" msprop:Generator_ColumnPropNameInTable="ghichuColumn" msprop:Generator_UserColumnName="ghichu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="uid" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnuid" msprop:Generator_ColumnPropNameInRow="uid" msprop:Generator_ColumnPropNameInTable="uidColumn" msprop:Generator_UserColumnName="uid" type="xs:string" />
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="getTCTonKho_TheKho_TheoLo_HanDung" msprop:Generator_TableClassName="getTCTonKho_TheKho_TheoLo_HanDungDataTable" msprop:Generator_TableVarName="tablegetTCTonKho_TheKho_TheoLo_HanDung" msprop:Generator_TablePropName="getTCTonKho_TheKho_TheoLo_HanDung" msprop:Generator_RowDeletingName="getTCTonKho_TheKho_TheoLo_HanDungRowDeleting" msprop:Generator_RowChangingName="getTCTonKho_TheKho_TheoLo_HanDungRowChanging" msprop:Generator_RowEvHandlerName="getTCTonKho_TheKho_TheoLo_HanDungRowChangeEventHandler" msprop:Generator_RowDeletedName="getTCTonKho_TheKho_TheoLo_HanDungRowDeleted" msprop:Generator_UserTableName="getTCTonKho_TheKho_TheoLo_HanDung" msprop:Generator_RowChangedName="getTCTonKho_TheKho_TheoLo_HanDungRowChanged" msprop:Generator_RowEvArgName="getTCTonKho_TheKho_TheoLo_HanDungRowChangeEvent" msprop:Generator_RowClassName="getTCTonKho_TheKho_TheoLo_HanDungRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngaychungtu" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnngaychungtu" msprop:Generator_ColumnPropNameInRow="ngaychungtu" msprop:Generator_ColumnPropNameInTable="ngaychungtuColumn" msprop:Generator_UserColumnName="ngaychungtu" type="xs:dateTime" minOccurs="0" />
              <xs:element name="sochungtu" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsochungtu" msprop:Generator_ColumnPropNameInRow="sochungtu" msprop:Generator_ColumnPropNameInTable="sochungtuColumn" msprop:Generator_UserColumnName="sochungtu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sohoadon" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsohoadon" msprop:Generator_ColumnPropNameInRow="sohoadon" msprop:Generator_ColumnPropNameInTable="sohoadonColumn" msprop:Generator_UserColumnName="sohoadon" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngayhoadon" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnngayhoadon" msprop:Generator_ColumnPropNameInRow="ngayhoadon" msprop:Generator_ColumnPropNameInTable="ngayhoadonColumn" msprop:Generator_UserColumnName="ngayhoadon" type="xs:dateTime" minOccurs="0" />
              <xs:element name="mahang" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnmahang" msprop:Generator_ColumnPropNameInRow="mahang" msprop:Generator_ColumnPropNameInTable="mahangColumn" msprop:Generator_UserColumnName="mahang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tenhang" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columntenhang" msprop:Generator_ColumnPropNameInRow="tenhang" msprop:Generator_ColumnPropNameInTable="tenhangColumn" msprop:Generator_UserColumnName="tenhang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dvt" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columndvt" msprop:Generator_ColumnPropNameInRow="dvt" msprop:Generator_ColumnPropNameInTable="dvtColumn" msprop:Generator_UserColumnName="dvt" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="quicach" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnquicach" msprop:Generator_ColumnPropNameInRow="quicach" msprop:Generator_ColumnPropNameInTable="quicachColumn" msprop:Generator_UserColumnName="quicach" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="solo" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsolo" msprop:Generator_ColumnPropNameInRow="solo" msprop:Generator_ColumnPropNameInTable="soloColumn" msprop:Generator_UserColumnName="solo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="hsd" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnhsd" msprop:Generator_ColumnPropNameInRow="hsd" msprop:Generator_ColumnPropNameInTable="hsdColumn" msprop:Generator_UserColumnName="hsd" type="xs:dateTime" minOccurs="0" />
              <xs:element name="soluongdauky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsoluongdauky" msprop:Generator_ColumnPropNameInRow="soluongdauky" msprop:Generator_ColumnPropNameInTable="soluongdaukyColumn" msprop:Generator_UserColumnName="soluongdauky" type="xs:decimal" minOccurs="0" />
              <xs:element name="soluongnhap" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsoluongnhap" msprop:Generator_ColumnPropNameInRow="soluongnhap" msprop:Generator_ColumnPropNameInTable="soluongnhapColumn" msprop:Generator_UserColumnName="soluongnhap" type="xs:decimal" minOccurs="0" />
              <xs:element name="soluongxuat" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsoluongxuat" msprop:Generator_ColumnPropNameInRow="soluongxuat" msprop:Generator_ColumnPropNameInTable="soluongxuatColumn" msprop:Generator_UserColumnName="soluongxuat" type="xs:decimal" minOccurs="0" />
              <xs:element name="soluongcuoiky" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsoluongcuoiky" msprop:Generator_ColumnPropNameInRow="soluongcuoiky" msprop:Generator_ColumnPropNameInTable="soluongcuoikyColumn" msprop:Generator_UserColumnName="soluongcuoiky" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DMIcd" msprop:Generator_TableClassName="DMIcdDataTable" msprop:Generator_TableVarName="tableDMIcd" msprop:Generator_TablePropName="DMIcd" msprop:Generator_RowDeletingName="DMIcdRowDeleting" msprop:Generator_RowChangingName="DMIcdRowChanging" msprop:Generator_RowEvHandlerName="DMIcdRowChangeEventHandler" msprop:Generator_RowDeletedName="DMIcdRowDeleted" msprop:Generator_UserTableName="DMIcd" msprop:Generator_RowChangedName="DMIcdRowChanged" msprop:Generator_RowEvArgName="DMIcdRowChangeEvent" msprop:Generator_RowClassName="DMIcdRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ten" msprop:Generator_ColumnVarNameInTable="columnten" msprop:Generator_ColumnPropNameInRow="ten" msprop:Generator_ColumnPropNameInTable="tenColumn" msprop:Generator_UserColumnName="ten" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tentienganh" msprop:Generator_ColumnVarNameInTable="columntentienganh" msprop:Generator_ColumnPropNameInRow="tentienganh" msprop:Generator_ColumnPropNameInTable="tentienganhColumn" msprop:Generator_UserColumnName="tentienganh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DMKhoa" msprop:Generator_TableClassName="DMKhoaDataTable" msprop:Generator_TableVarName="tableDMKhoa" msprop:Generator_TablePropName="DMKhoa" msprop:Generator_RowDeletingName="DMKhoaRowDeleting" msprop:Generator_RowChangingName="DMKhoaRowChanging" msprop:Generator_RowEvHandlerName="DMKhoaRowChangeEventHandler" msprop:Generator_RowDeletedName="DMKhoaRowDeleted" msprop:Generator_UserTableName="DMKhoa" msprop:Generator_RowChangedName="DMKhoaRowChanged" msprop:Generator_RowEvArgName="DMKhoaRowChangeEvent" msprop:Generator_RowClassName="DMKhoaRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ten" msprop:Generator_ColumnVarNameInTable="columnten" msprop:Generator_ColumnPropNameInRow="ten" msprop:Generator_ColumnPropNameInTable="tenColumn" msprop:Generator_UserColumnName="ten" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ghichu" msprop:Generator_ColumnVarNameInTable="columnghichu" msprop:Generator_ColumnPropNameInRow="ghichu" msprop:Generator_ColumnPropNameInTable="ghichuColumn" msprop:Generator_UserColumnName="ghichu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tinhtrang" msprop:Generator_ColumnVarNameInTable="columntinhtrang" msprop:Generator_ColumnPropNameInRow="tinhtrang" msprop:Generator_ColumnPropNameInTable="tinhtrangColumn" msprop:Generator_UserColumnName="tinhtrang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chinhanh" msprop:Generator_ColumnVarNameInTable="columnchinhanh" msprop:Generator_ColumnPropNameInRow="chinhanh" msprop:Generator_ColumnPropNameInTable="chinhanhColumn" msprop:Generator_UserColumnName="chinhanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DoSinhHieu" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="DoSinhHieuTienSuBenh_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DoSinhHieuTienSuBenh" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="DMIcd_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DMIcd" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="DMKhoa_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DMKhoa" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_DoSinhHieuTienSuBenh_DoSinhHieu" msdata:parent="DoSinhHieu" msdata:child="DoSinhHieuTienSuBenh" msdata:parentkey="ma" msdata:childkey="ma" msprop:Generator_UserChildTable="DoSinhHieuTienSuBenh" msprop:Generator_ChildPropName="GetDoSinhHieuTienSuBenhRows" msprop:Generator_UserRelationName="FK_DoSinhHieuTienSuBenh_DoSinhHieu" msprop:Generator_RelationVarName="relationFK_DoSinhHieuTienSuBenh_DoSinhHieu" msprop:Generator_UserParentTable="DoSinhHieu" msprop:Generator_ParentPropName="DoSinhHieuRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>